<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Sorting grouping fields</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
p.whs3 { margin-left:80px; }
p.whs4 { margin-left:40px; }
p.whs5 { margin-left:0px; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs5 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nGrouping and sorting data in a document\nSorting data in a document\nSorting grouping fields");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Sorting grouping fields</h1>
<p>Grouping records helps people who read the document understand the data 
 better. Grouping the data sets up a type of hierarchy within the document, 
 and an inherent or implied sort order for the data in the document. The 
 data is sorted first by the first field in the Grouping panel, then by 
 the next field, and so on. To reorder the grouping, you can move the fields 
 in the Grouping panel (as described in the procedure below). </p>
<p>You can select which grouping fields to sort, the sorting criteria (what 
 to sort by), and the sorting order (ascending or descending). Any object 
 in the Grouping panel can be sorted. </p>
<ul type="disc" class="whs1">
	
<li class=p><p>If the object is an attribute, an ascending sort orders 
 the data from smallest to largest, such as A - Z, or 1-10. If you choose 
 descending order then the data appears from largest to smallest, such 
 as Z - A, or 10 - 1.</p></li>
	
<li class=p><p>If the object is a consolidation, you cannot change 
 the order. You can change the sorting criteria from top to bottom. Top 
 means that the element name is displayed first, then the individual items. 
 Bottom means that the individual items of an element are displayed first, 
 followed by the element name. However, for these options to affect the 
 document, the custom group must be displayed as Show only the individual 
 items within this element and also, expand these individual items if possible 
 or Show element names, individual items within this element and also, 
 expand these individual items if possible. </p></li>
	
<li class=p><p>If the object is a custom group, an ascending sort displays 
 the elements in the order in which they were defined. Descending order 
 reverses that order. </p></li>
</ul>
<h2>Prerequisites</h2>
<p>To specify whether a custom group is sorted first by the element or 
 by the element's individual items, the custom group must be displayed 
 as either of the following in the Custom Group Editor in MicroStrategy 
 Desktop. For more information, contact your administrator.</p>
<ul type="disc" class="whs1">
	
<li class=p><p>Show only the individual items within this element and 
 also, expand these individual items if possible</p></li>
	
<li class=p><p>Show element names, individual items within this element 
 and also, expand these individual items if possible</p></li>
</ul>
<h2>To sort grouping fields</h2>
<ol type="1" class="whs2">
	
<li class=p><p>Open the document in <span style="font-weight: bold;"><B>Design 
 </B></span>or <span style="font-weight: bold;"><B>Editable Mode</B></span>. &nbsp;</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Data</B></span> 
 menu, select <span style="font-weight: bold;"><B>Sort Document</B></span>. The 
 Sort Document&nbsp;dialog box opens. </p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Sort By</B></span> 
 drop-down list in the Grouping area, select the object to sort. The list 
 contains all the objects in the primary dataset, regardless of where or 
 whether they are placed on the document.</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If the Sort 
 By object is an attribute, select which attribute form to sort on.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>If the Sort 
 By object is a custom group, from the <span style="font-weight: bold;"><B>Criteria</B></span> 
 drop-down list, select from the following options:</p></li>
		<ul>
<li style="list-style: disc;" type=disc class=p><p><span style="font-weight: bold;"><B>Default</B></span>: 
 inherits the sort property of the custom group</p></li>
			
<li style="list-style: disc;" type=disc class=p><p><span style="font-weight: bold;"><B>Top</B></span>: 
 the element name is displayed first, then its individual items</p></li>
			
<li style="list-style: disc;" type=disc class=p><p><span style="font-weight: bold;"><B>Bottom</B></span>: 
 the individual items of an element are displayed, followed by the element 
 name</p></li>
		</ul>
	</ul>
</ol>
<p class="whs3"><span style="font-weight: bold;"><B>Note</B></span>: 
 These options affect the document only if the custom group is displayed 
 as &quot;Show only the individual items within this element and also, 
 expand these individual items if possible&quot; or &quot;Show element 
 names, individual items within this element and also, expand these individual 
 items if possible&quot;. &nbsp;</p>
<ol type="1" class="whs2">
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If the Sort 
 By object is a consolidation or metric, the only option is <span style="font-weight: bold;"><B>Default</B></span>. 
 </p></li>
	</ul>
</ol>
<ol start="4" type="1" class="whs2">
	
<li class=p><p>Select <span style="font-weight: bold;"><B>Ascending</B></span> 
 or <span style="font-weight: bold;"><B>Descending</B></span> for each object. 
 </p></li>
</ol>
<p class="whs4"><span style="font-weight: bold;"><B>Note</B></span>: 
 You cannot change the Order if the Criteria of an attribute is set to 
 Default. You can change the order of a custom group only if you selected 
 Sort on Attribute ID in the Criteria. </p>
<ol start="5" type="1" class="whs2">
	
<li class=p><p class="whs5">Change each grouping field 
 as necessary. When you are done, click <span style="font-weight: bold;"><B>OK</B></span> 
 to apply the changes.</p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
